SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Tucked back from the road on a delightful, private lot just under 1.5 miles from the Dartmouth College campus and downtown Hanover, this thoughtfully maintained 4-bedroom, 2-full bath ranch offers a rare blend of comfort, convenience, and understated elegance. From the moment you arrive, the setting feels peaceful yet connected — a place where daily life unfolds with ease. Designed for effortless single-level living, the home welcomes you from the attached two-car garage directly into a bright kitchen with new counter tops that flows naturally into the dining area, where a slider opens to the spacious rear deck — an inviting extension of the living space for quiet mornings or relaxed gatherings. The living room is warm and welcoming, anchored by a woodstove that adds both character and comfort throughout the seasons, with a private office just off the living room providing ideal space for work or study. Four well-proportioned bedrooms offer flexibility for family or guests, including a spacious primary suite with its own full bath, direct access to the shared rear deck, and the added convenience of laundry located within the walk-in closet — enhancing the ease of everyday living. Public water and sewer add practicality, while the large unfinished basement provides abundant storage. Offering privacy, thoughtful design, and close proximity to Dartmouth and Hanover’s vibrant downtown, this home captures the balance of tranquility and accessibility that defines Upper Valley living.
Description:What a gem situated within the big little city of Lebanon, NH. Built during the Eastlake Architectural movement in 1860 this Victorian home has all the features one expects to see for the time period including ornate floral carvings that adorn the exterior. Tastefully updated by the few owners who have appreciated her history, this home provides ample space for cohabitation of one or more generations of occupants. Off the rear of the home, where you will find ample parking, is a separate entrance that could be used as a home based office complete with kitchenette and bathroom. It can even serve as quarters for an in home assistant to the residents or good friend or family member. From the front or side covered porch you enter the main home and appreciate the history that flows from its rooms. Two options for a first floor bedroom are available for those who desire or need single level living. A three season sunroom on the second floor could function as a game room, exercise space or a space to entertain or hang 10; the possibilities abound. Combine this with ample sized sleeping rooms including an impressive primary suite, the second floor fosters a feeling of home with its comfort and warmth. The basement would make for an impressive home based gym essential for the winter months when we feel somewhat trapped by the weather or perhaps even a daycare as I understand it once was. Walking distance to the Marsh Brothers Deli, Lucky's Coffee House, Village Pizzeria, Salthill Irish pub, Three Tomatoes Italian Restaurant and Lebanon Opera House means the property is near the Lebanon Green famous for its outdoor concerts, farmers markets and festivals. Perhaps you're interested in an investment property vs. a single family dwelling? This home and layout provides many opportunities.
Description:Set on over 76 private acres, this Cape Cod style home offers the perfect blend of comfort, practicality, and direct access to the outdoors. The home features four bedrooms and three bathrooms, including a generous primary suite with an ensuite bath. The open-concept kitchen, dining, and living areas create a welcoming space for everyday living and entertaining. A mudroom with a new pellet stove adds warmth and utility, while a full basement and large detached garage provide ample room for storage, including all your outdoor gear. Take in sweeping, unobstructed views of Smarts Mountain from the inviting farmers porch, an ideal spot to relax after a day spent exploring. This is truly a private outdoor retreat. A two-mile trail winds through the property, perfect for cross-country skiing, snowshoeing, or mountain biking. Make your own maple syrup in the super comfortable sugar shack. Tucked into the woods, a treehouse offers a charming escape for kids or adults alike. Beyond the property, find easy access to the Green Woodlands, home to miles of perfectly groomed cross-country skiing and mountain bike trails, as well as the Appalachian Trail and Dartmouth Skiway. Just 15 minutes to the center of Lyme and under 30 minutes to Hanover, this is a rare opportunity to own a spacious, private property in a truly exceptional location. A dream for outdoor enthusiasts and anyone seeking space, and year-round adventure.
Description:Spacious, move-in-ready, contemporary home with 3 bedrooms plus a bonus room, 4.5 baths and over 3,000 SF. Ideally situated on 2+ acres with privacy and views of the meadow and pond. Property abuts Grantham Recreational Park and conservation land. You’ll absolutely love the state-of-the-art kitchen featuring granite countertops, a large island, walk-in pantry, professional-grade gas range, custom tile backsplash, and two dishwashers. The open layout flows into a dining area and continues to an expansive living room with vaulted ceilings and a beautiful fireplace as the focal point. The first-floor primary suite offers a generous walk-in closet and two separate baths for convenience. Two more bedrooms, each with its own bath, and a bonus room are on the lower level. You'll also find a family room filled with natural light in the walkout lower level. Additional highlights include a home office, whole-house generator, direct entry from the 2-car garage, a screened porch, and large wraparound deck. Located just minutes from I-89, this property provides easy access to the Upper Valley and Dartmouth-Lake Sunapee Region. The area offers year-round opportunities for outdoor recreation including kayaking, fishing, skiing, ice skating, and more. All this in a lovely country setting.
Description:This 3 bed, 3 bath home is perfectly situated in the desirable Fieldstone Ridge neighborhood with views to Cardigan Mountain. You will fall in love with the light filled, open concept spaces including a wonderful sunroom with seasonal views of the Whaleback ski area ridge line. Enjoy the ease of one level living with a primary suite with a double sided propane fireplace, beautifully renovated 3/4 bath and a large walk-in closet as well as a designated laundry space all conveniently located on the main level. Upstairs there are 2 oversized bedrooms and a full bath. Still need more space? The full walk out basement is unfinished but has endless possibilities to add more living space, an office, exercise area and workshop. Bring your ideas and join this lovely community. Neighbors gather for hikes, snow shoeing and annual parties if you wish. Otherwise keep to yourself and enjoy the easy accessibility to downtown Lebanon, Dartmouth Health within 15 mins and Hanover just under 20 minutes away. The perfect spot to enjoy the Upper Valley lifestyle. Showings begin on Friday 3/27 at the Open House from 12-2. Saturday Open House 10-12.